www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/lxrxx.cpp
// lxrxx.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "lxrxx.h" #include "ado.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ado rst2; int num=1; int num2; int sel=1; int xiugai; ///////////////////////////////////////////////////////////////////////////// // lxrxx dialog lxrxx::lxrxx(CWnd* pParent /*=NULL*/) : CDialog(lxrxx::IDD, pParent) { //{{AFX_DATA_INIT(lxrxx) //}}AFX_DATA_INIT } void lxrxx::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(lxrxx) DDX_Control(pDX, IDC_EDIT9, m_edit9); DDX_Control(pDX, IDC_EDIT8, m_edit8); DDX_Control(pDX, IDC_EDIT7, m_edit7); DDX_Control(pDX, IDC_EDIT6, m_edit6); DDX_Control(pDX, IDC_EDIT5, m_edit5); DDX_Control(pDX, IDC_EDIT4, m_edit4); DDX_Control(pDX, IDC_EDIT3, m_edit3); DDX_Control(pDX, IDC_EDIT2, m_edit2); DDX_Control(pDX, IDC_EDIT1, m_edit1); DDX_Control(pDX, IDC_DATETIMEPICKER2, m_date2); DDX_Control(pDX, IDC_DATETIMEPICKER1, m_date1); DDX_Control(pDX, IDC_COMBO2, m_com2); DDX_Control(pDX, IDC_COMBO3, m_com3); DDX_Control(pDX, IDC_COMBO1, m_com1); DDX_Control(pDX, IDC_LIST1, m_list); DDX_Control(pDX, IDC_TAB1, m_tab); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(lxrxx, CDialog) //{{AFX_MSG_MAP(lxrxx) ON_COMMAND(ID_ADD, OnAdd) ON_COMMAND(ID_DELETE, OnDelete) ON_COMMAND(ID_EXIT, OnExit) ON_COMMAND(ID_FIRST, OnFirst) ON_COMMAND(ID_LAST, OnLast) ON_COMMAND(ID_NEXT, OnNext) ON_COMMAND(ID_SAVE, OnSave) ON_COMMAND(ID_UP, OnUp) ON_COMMAND(ID_UPDATE, OnUpdate) ON_WM_PAINT() ON_COMMAND(ID_CANCEL, OnCancel) ON_NOTIFY(TCN_SELCHANGE, IDC_TAB1, OnSelchangeTab1) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // lxrxx message handlers void lxrxx::OnAdd() { m_tab.SetCurSel(0); this->textshow(); this->enableall(true); this->enbutton(false); this->clearall(); this->numauto(); sel=0; xiugai=0; } void lxrxx::OnCancel() { this->textshow(); this->datatotext(); this->texttowin(); this->enableall(false); this->enbutton(true); sel=1; } void lxrxx::OnDelete() { if(MessageBox("删除后数据将丢失","提示",MB_YESNO)==IDYES) { CString ss,aa; this->m_edit1.GetWindowText(aa); ss.Format("delete from tb_Client_lxrxx where lxrxx_id = '%s'",aa); rst2.ExecuteSQL(ss); m_list.DeleteAllItems(); this->loadf(); this->load2(); this->datatotext(); this->texttowin(); } } void lxrxx::OnExit() { CDialog::EndDialog(true); } void lxrxx::OnFirst() { m_tab.SetCurSel(0); this->textshow(); rst2.MoveFirst(); this->datatotext(); this->texttowin(); num=1; } void lxrxx::OnLast() { m_tab.SetCurSel(0); this->textshow(); rst2.MoveLast(); this->datatotext(); this->texttowin(); num=num2; } void lxrxx::OnNext() { if(num==num2) {return;} m_tab.SetCurSel(0); this->textshow(); rst2.MoveNext(); this->datatotext(); this->texttowin(); num+=1; } void lxrxx::OnSave() { this->wintotext(); CString ss; if(xiugai==1) {ss.Format("UPDATE tb_Client_lxrxx set lxrxx_qymc='%s',lxrxx_xm='%s',lxrxx_xb='%s',lxrxx_nl='%s',lxrxx_zw='%s',lxrxx_bgdh='%s',lxrxx_Email='%s',lxrxx_csny='%s',lxrxx_sj='%s',lxrxx_grjj='%s',lxrxx_djrq='%s',lxrxx_xxdjr='%s',lxrxx_bz='%s' where lxrxx_id='%s'",com1,edit2,com2,edit3,com3,edit4,edit5,date1,edit6,edit7,date2,edit8,edit9,edit1);} else {ss.Format("INSERT INTO tb_Client_lxrxx values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",edit1,com1,edit2,com2,date1,edit3,com3,edit4,edit5,edit6,edit7,date2,edit8,edit9);} rst2.ExecuteSQL(ss); m_list.DeleteAllItems(); this->loadf(); this->load2(); this->datatotext(); this->texttowin(); this->enableall(false); this->enbutton(true); sel=1; xiugai=0; } void lxrxx::OnUp() { if(num==1) {return;} m_tab.SetCurSel(0); this->textshow(); rst2.MovePrevious(); this->datatotext(); this->texttowin(); num-=1; } void lxrxx::OnUpdate() { m_tab.SetCurSel(0); this->textshow(); this->enableall(true); this->enbutton(false); sel=0; xiugai=1; } BOOL lxrxx::OnInitDialog() { CDialog::OnInitDialog(); this->m_com2.AddString("男"); this->m_com2.AddString("女"); this->m_com3.AddString("董事长"); this->m_com3.AddString("总经理"); this->m_com3.AddString("销售主管"); this->m_com3.AddString("市场主管"); this->m_com3.AddString("宣传主管"); this->m_com3.AddString("总工程师"); this->m_com3.AddString("外联主管"); this->m_com3.AddString("人力资源主管"); this->m_com3.AddString("职员"); ado load; load.Open("select * from tb_khxx",adCmdText); int rstnum=load.GetRecordCount(); int l; for(l=1;l<=rstnum;l++) { this->m_com1.AddString(load.GetFieldValue("khxx_mc")); load.Move(l); } load.close(); imagelist.Create(32,32,ILC_COLOR32|ILC_MASK,0,0); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON1))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON2))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON3))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON4))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON5))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON6))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON7))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON8))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON9))); imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON10))); // int weith[2]; // weith[1]=150; // weith[0]=500; // weith[2]=200; CString s; TCHAR *pString; CMenu menu; menu.LoadMenu(IDR_lxrxx); // this->SetMenu(&menu); toolbar.EnableAutomation(); toolbar.Create(WS_CHILD|WS_VISIBLE,CRect(0,0,0,0),this,ID_TOOLBAR); toolbar.SetImageList(&imagelist); TBBUTTON button[12]; int i; for(i=0;i<12;i++) { button[i].dwData=0; button[i].fsState=TBSTATE_ENABLED; button[i].fsStyle=TBSTYLE_BUTTON; } button[5].fsStyle=TBSTYLE_SEP; button[10].fsStyle=TBSTYLE_SEP; button[0].idCommand=ID_ADD; button[0].iBitmap=0; button[1].idCommand=ID_UPDATE; button[1].iBitmap=1; button[2].idCommand=ID_DELETE; button[2].iBitmap=2; button[3].idCommand=ID_SAVE; button[3].iBitmap=3; button[4].idCommand=ID_CANCEL; button[4].iBitmap=4; button[6].idCommand=ID_FIRST; button[6].iBitmap=5; button[7].idCommand=ID_UP; button[7].iBitmap=6; button[8].idCommand=ID_NEXT; button[8].iBitmap=7; button[9].idCommand=ID_LAST; button[9].iBitmap=8; button[11].idCommand=ID_EXIT; button[11].iBitmap=9; for(i=0;i<12;i++) { s.LoadString(i+IDS_1); int nStringLength= s.GetLength() + 1; pString = s.GetBufferSetLength(nStringLength); button[i].iString =toolbar.AddStrings(pString); s.ReleaseBuffer(); } toolbar.AddButtons(12,button); toolbar.AutoSize(); toolbar.SetStyle(TBSTYLE_FLAT|CCS_TOP); toolbar.EnableButton(ID_SAVE,false); toolbar.EnableButton(ID_CANCEL,false); m_list.ModifyStyle(0L,LVS_REPORT); m_list.ModifyStyle(0L,LVS_SINGLESEL); m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS); m_list.ModifyStyle(0L,LVS_NOSORTHEADER); m_list.SetExtendedStyle(LVS_EX_GRIDLINES); m_list.InsertColumn(0,"联系人编号"); m_list.InsertColumn(1,"企业名称"); m_list.InsertColumn(2,"联系人姓名"); m_list.InsertColumn(3,"联系人性别"); m_list.InsertColumn(4,"年龄"); m_list.InsertColumn(5,"职位"); m_list.InsertColumn(6,"办公电话"); m_list.InsertColumn(7,"电子邮件"); m_list.InsertColumn(8,"手机"); m_list.SetColumnWidth(0,100); m_list.SetColumnWidth(1,100); m_list.SetColumnWidth(2,100); m_list.SetColumnWidth(3,100); m_list.SetColumnWidth(4,100); m_list.SetColumnWidth(5,100); m_list.SetColumnWidth(6,100); m_list.SetColumnWidth(7,100); m_list.SetColumnWidth(8,100); m_tab.InsertItem(0,"联系人基本信息"); m_tab.InsertItem(1,"联系人列表"); this->load2(); this->loadf(); this->texttowin(); m_list.ShowWindow(SW_HIDE); enableall(false); this->m_edit3.LimitText(2); //statebar.EnableAutomation(); //if(!statebar.Create(WS_CHILD|WS_VISIBLE,CRect(0,0,0,0),this,ID_STATU)) //{ // return false; //} //statebar.SetParts(4,&weith[1]); //statebar.SetText("明日",0,0); //statebar.SetText("aa",0,3); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void lxrxx::OnPaint() { CPaintDC dc(this); // device context for painting if (IsIconic()) { SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0); // Center icon in client rectangle int cxIcon = GetSystemMetrics(SM_CXICON); int cyIcon = GetSystemMetrics(SM_CYICON); CRect rect; GetClientRect(&rect); int x = (rect.Width() - cxIcon + 1) / 2; int y = (rect.Height() - cyIcon + 1) / 2; // dc.DrawIcon(x, y, m_hIcon); } else { CDialog::OnPaint(); } } BOOL lxrxx::PreTranslateMessage(MSG* pMsg) { // TODO: Add your specialized code here and/or call the base class if(pMsg->message==WM_KEYDOWN && pMsg->wParam==13) pMsg->wParam=9; return CDialog::PreTranslateMessage(pMsg); } //void lxrxx::show(bool enbale) //{ //} void lxrxx::OnSelchangeTab1(NMHDR* pNMHDR, LRESULT* pResult) { if(sel==1) { int i=m_tab.GetCurSel(); switch(i) { case 1: this->listshow(); break; case 0: this->textshow(); break; } } *pResult = 0; } void lxrxx::enableall(bool b) { m_edit1.EnableWindow(b); m_edit2.EnableWindow(b); m_edit3.EnableWindow(b); m_edit4.EnableWindow(b); m_edit5.EnableWindow(b); m_edit6.EnableWindow(b); m_edit7.EnableWindow(b); m_edit8.EnableWindow(b); m_edit9.EnableWindow(b); m_com1.EnableWindow(b); m_com2.EnableWindow(b); m_com3.EnableWindow(b); m_date1.EnableWindow(b); m_date2.EnableWindow(b); } void lxrxx::wintotext() { this->m_edit1.GetWindowText(edit1); this->m_edit2.GetWindowText(edit2); this->m_edit3.GetWindowText(edit3); this->m_edit4.GetWindowText(edit4); this->m_edit5.GetWindowText(edit5); this->m_edit6.GetWindowText(edit6); this->m_edit7.GetWindowText(edit7); this->m_edit8.GetWindowText(edit8); this->m_edit9.GetWindowText(edit9); this->m_com1.GetWindowText(com1); this->m_com2.GetWindowText(com2); this->m_com3.GetWindowText(com3); this->m_date1.GetWindowText(date1); this->m_date2.GetWindowText(date2); } void lxrxx::texttowin() { this->m_edit1.SetWindowText(edit1); this->m_edit2.SetWindowText(edit2); this->m_edit3.SetWindowText(edit3); this->m_edit4.SetWindowText(edit4); this->m_edit5.SetWindowText(edit5); this->m_edit6.SetWindowText(edit6); this->m_edit7.SetWindowText(edit7); this->m_edit8.SetWindowText(edit8); this->m_edit9.SetWindowText(edit9); this->m_com1.SetWindowText(com1); this->m_com2.SetWindowText(com2); this->m_com3.SetWindowText(com3); this->m_date1.SetWindowText(date1); this->m_date2.SetWindowText(date2); } void lxrxx::clearall() { this->m_edit1.SetWindowText(""); this->m_edit2.SetWindowText(""); this->m_edit3.SetWindowText(""); this->m_edit4.SetWindowText(""); this->m_edit5.SetWindowText(""); this->m_edit6.SetWindowText(""); this->m_edit7.SetWindowText(""); this->m_edit8.SetWindowText(""); this->m_edit9.SetWindowText(""); this->m_com1.SetWindowText(""); this->m_com2.SetWindowText(""); this->m_com3.SetWindowText(""); this->m_date1.SetWindowText(""); this->m_date2.SetWindowText(""); } void lxrxx::datatotext() { edit1=rst2.GetFieldValue("lxrxx_id"); com1=rst2.GetFieldValue("lxrxx_qymc"); edit2=rst2.GetFieldValue("lxrxx_xm"); com2=rst2.GetFieldValue("lxrxx_xb"); edit3=rst2.GetFieldValue("lxrxx_nl"); com3=rst2.GetFieldValue("lxrxx_zw"); edit4=rst2.GetFieldValue("lxrxx_bgdh"); edit5=rst2.GetFieldValue("lxrxx_Email"); date1=rst2.GetFieldValue("lxrxx_csny"); edit6=rst2.GetFieldValue("lxrxx_sj"); edit7=rst2.GetFieldValue("lxrxx_grjj"); date2=rst2.GetFieldValue("lxrxx_djrq"); edit8=rst2.GetFieldValue("lxrxx_xxdjr"); edit9=rst2.GetFieldValue("lxrxx_bz"); } void lxrxx::listshow() { m_list.ShowWindow(SW_SHOW); m_edit1.ShowWindow(SW_HIDE); m_edit2.ShowWindow(SW_HIDE); m_edit3.ShowWindow(SW_HIDE); m_edit4.ShowWindow(SW_HIDE); m_edit5.ShowWindow(SW_HIDE); m_edit6.ShowWindow(SW_HIDE); m_edit7.ShowWindow(SW_HIDE); m_edit8.ShowWindow(SW_HIDE); m_edit9.ShowWindow(SW_HIDE); m_com1.ShowWindow(SW_HIDE); m_com2.ShowWindow(SW_HIDE); m_com3.ShowWindow(SW_HIDE); m_date1.ShowWindow(SW_HIDE); m_date2.ShowWindow(SW_HIDE); } void lxrxx::textshow() { m_list.ShowWindow(SW_HIDE); m_edit1.ShowWindow(SW_SHOW); m_edit2.ShowWindow(SW_SHOW); m_edit3.ShowWindow(SW_SHOW); m_edit4.ShowWindow(SW_SHOW); m_edit5.ShowWindow(SW_SHOW); m_edit6.ShowWindow(SW_SHOW); m_edit7.ShowWindow(SW_SHOW); m_edit8.ShowWindow(SW_SHOW); m_edit9.ShowWindow(SW_SHOW); m_com1.ShowWindow(SW_SHOW); m_com2.ShowWindow(SW_SHOW); m_com3.ShowWindow(SW_SHOW); m_date1.ShowWindow(SW_SHOW); m_date2.ShowWindow(SW_SHOW); } void lxrxx::numauto() { ado rst3; rst3.rstOpen("select * from tb_Client_lxrxx"); if(rst3.GetRecordCount()==0) { this->m_edit1.SetWindowText("LXR001"); this->m_edit1.EnableWindow(false); return; } rst3.rstOpen("select * from tb_Client_lxrxx"); rst3.MoveLast(); CString mm=rst3.GetFieldValue("lxrxx_id"); int xuhao=atoi(mm.Right(3)); xuhao+=1; mm.Format("LXR%03d",xuhao); this->m_edit1.EnableWindow(false); this->m_edit1.SetWindowText(mm); rst3.close(); } void lxrxx::enbutton(bool butn) { toolbar.EnableButton(ID_ADD,butn); toolbar.EnableButton(ID_UPDATE,butn); toolbar.EnableButton(ID_DELETE,butn); toolbar.EnableButton(ID_UP,butn); toolbar.EnableButton(ID_NEXT,butn); toolbar.EnableButton(ID_FIRST,butn); toolbar.EnableButton(ID_LAST,butn); toolbar.EnableButton(ID_SAVE,!butn); toolbar.EnableButton(ID_CANCEL,!butn); } void lxrxx::loadf() {/* if(chuan.IsEmpty()) {rst2.rstOpen("select * from tb_Client_lxrxx");} else MessageBox(chuan); chuanSQL.Format("select * from tb_Client_lxrxx where lxrxx_id='%s'",chuan); {rst2.Open(chuanSQL,adCmdText);} */ rst2.rstOpen("select * from tb_Client_lxrxx"); num2=rst2.GetRecordCount(); //rst.MoveFirst(); edit1=rst2.GetFieldValue("lxrxx_id"); com1=rst2.GetFieldValue("lxrxx_qymc"); edit2=rst2.GetFieldValue("lxrxx_xm"); com2=rst2.GetFieldValue("lxrxx_xb"); edit3=rst2.GetFieldValue("lxrxx_nl"); com3=rst2.GetFieldValue("lxrxx_zw"); edit4=rst2.GetFieldValue("lxrxx_bgdh"); edit5=rst2.GetFieldValue("lxrxx_Email"); date1=rst2.GetFieldValue("lxrxx_csny"); edit6=rst2.GetFieldValue("lxrxx_sj"); edit7=rst2.GetFieldValue("lxrxx_grjj"); date2=rst2.GetFieldValue("lxrxx_djrq"); edit8=rst2.GetFieldValue("lxrxx_xxdjr"); edit9=rst2.GetFieldValue("lxrxx_bz"); } void lxrxx::load2() { ado rst; rst.Open("select * from tb_Client_lxrxx",adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj")); rst.Move(ii); } rst.close(); }